EMT Practice Test

1. Question Content...

---

Question1: Which Data source can a report author connect to directly when creating a Dashboard?

Question2: An author wants to add a visualization to a Dashboard that emphasizes the magnitude of change in data over time.
Which type of visualization should be used?

Question3: A report author wants to display the report name on the report page.
Which type of calculation should be used?

Question4: A report developer is tasked to create a drill-through definition in a report.
Which are the generalized steps?

Question5: A company would like to implement their own corporate style across all reports using a single Report as a reference. A requirement is to display the year of the data selected in the report in the header. The year is not being resolved correctly as shown below:

How can the problem with this report be resolved?

Question6: A report author has added a Button Bar control to an Active Report that allows users to view data for different regions. The report author now wants to make it possible for users to filter the report on multiple regions at once.
What should the report author do?

Question7: A report author has the following filter in a report:
[Product line] in ?pline?
The report author adds a Value prompt based on the existing parameter 'pline'. After adding the prompt, the Auto-submit property is defaulted to 'No' and cannot be changed to 'Yes'.
What is the cause of this?

Question8: A report contains multiple queries that are joined to form the report, resulting in poor performance. The company's policy prohibits the use of user-defined SQL statements within reports.
What should be done to improve report performance?

Question9: A report author wants to create an Active Report with a Data deck that only prompts for Product line and Year. For each card created, the Order method type broken down by revenue should be shown.
What needs to be done to ensure the data on each card reflects the correct year and Product line?

Question10: A report author has created this join relationship:

The Order number by product query includes only orders that contain a specific product selected at run time.
What must the report author do to ensure that the joined query will only contain Order numbers that appear in both of the queries?

Question11: A report author wants to ensure a complete mobile experience on an iPad tablet by enabling swipe gesturing between pages of a Data deck.
What must be done to achieve this?

Question12: How can an Uploaded file be combined with data from a database?

Question13: A report author wants to display Revenue and Quantity by Product line in one chart and use a combination chart. A bar chart is used for revenue and a line chart for quantity. While the bar chart is clear and easy to understand, the lines are almost missing and are different to read.
What can be done to solve the problem?

Question14: What can be done when using a SQL object when not using a stored procedure?

Question15: A company distributes a monthly email to the sales managers at the beginning of each month that shows how well they are doing using a tabular formatted report. The report is delivered in Excel format and the sales managers would like the report to be in a Crosstab format.
How should the report be changed?

Question16: How can a report author ensure that a report changes automatically when rotating a mobile device between Landscape and Portrait views?

Question17: What should a report author do to use data from two tabs of an Excel file (.xlsx) together in a single object in a Dashboard?

Question18: A report author created a crosstab as shown below:

The crosstab report, when run, shows the following data:

The author wants to split the revenue for each region by year.
Where should the year data item be added?

Question19: A report author had created a single select value prompt using the prompt wizard. The end user now needs to select more than one value.
What should the report author do?

Question20: A report author needs to create an offline interactive report that can be filtered by clicking on a list of values. For example, by clicking on Region "A" the List will display only the details from Region "A".
Which Reaction behavior should be selected?

Question21: When using a SQL object, what is the property SQL syntax by default?

Question22: A report author uploads files into Cognos Analytics - Reporting.
Which file formats are supported? (Choose two.)

Question23: A report author has to create a Crosstab report with Region and Product data in the rows of the Crosstab.
The Crosstab can be created in two different ways as shown below.

Which Crosstab/Crosstabs is/are discontinuous Crosstab/Crosstabs?

Question24: A report author would like to reuse a logo across all existing reports.
Which object should be used?

Question25: A user is creating a Dashboard from an uploaded file and an additional Data source is needed.
From which source can the additional data be used directly?

Question26: How can a package be created?

Question27: The sales department has requested the report author to build a report which combines a list with a chart.
The list must contain product lines and the chart should show details for each product line. The report author decided to use a Master detail relationship to build this report.
Which statement about Master detail relationships is true?

Question28: A report author wants to nest a chart within a list and filter the chart data to relate to the row of the list that it is displayed in.
How can this be done?

Question29: A report author wants to create an Active Report with a chart that is dynamically rendered in the browser based on user selections.
How can this be accomplished?

Question30: A report author has created a report as shown below:

What has been defined during the building of this report?

Question31: A report author created the following list report and wants to filter all order methods which generated total revenue less than one billion.

Which filter should be used?

Question32: A report author is going to develop a report and wants to ensure that the layout if defined correctly.
What should be done first?

Question33: A report author has been asked to create a report that needs to be distributed in PDF format. The report has to let users navigate quickly to a desired report page and information within the report.
How can this be accomplished?

Question34: A report author has been asked to create a list report with multiple facts from across the business. The desired outcome must ensure correlated and predictable results.
Which item must be included in the list report?

Question35: A report author is building an Active Report for disconnected mobile use only.
Which technique can be used while ensuring the Active Report is fully offline capable?

Question36: A report author wants to conditionally format data depending on a parameter value a user specifies at run time.
How can this be done?

Question37: A company has a Product Returns report. The Return Comments query item is present in the list query but was left out of the list due to space constraints on the report page. The users have asked to see this information interactively.
How could the report author add this functionality with only minimal changes to the existing report?

Question38: An Active Report contains a data deck with the following values on multi select controls:

How many cards would be generated?

Question39: A report author would like to create multiple variable connections in a report that contains one control and two Lists in order to compare data.
Which statement is true?

Question40: A report author creates the following filter in a report:
[Region] in ('Americas','Asia Pacific')
Which type of filter was created?

Question41: What does a developer need to know in order to expose Cognos Analytics Dashboards for mobile consumption?

Question42: An author wants to set a single value that will filter all other visualizations affected by its value.
Which visualization type should be used?

Question43: A report author needs to verify that the cardinality is set correctly in order to properly group a list report.
What is the correct setting?

Question44: A report author has created a Dashboard visualization and needs to filter it on a data item that is not displayed.
How can this be accomplished?

Question45: A customer wants to have a report with a bar chart, which is going to be displayed on a tablet. By changing a filter on the report, the chart should change dynamically. The report output size should be as small as possible.
How can this be achieved?

Question46: A report author has applied one style in specific cells, and another style for the overall report.
Which style will be applied?

Question47: A report author has applied a Union set operation on two queries with the resultant query named Main_Query containing the data items: Product line, Order method/Region, Revenue and Unit Sale Price.
The report author added the data items to the list, grouped on Product line and Order method/Region. The screenshot below shows the result:

What must the report author do for the report to look like the following?

Question48: What happens when a report is run with full interactivity?

Question49: An author has finished working on a Dashboard and wants to make it available to other authors.
Where should the Dashboard be located?

Question50: Which statement is true when a report author wants to optimize reports for mobile users?

Question51: A company would like to distribute reports to users via an email address or a directory entry.
How should the burst table be defined for this to work appropriately?

Question52: An author has created a dashboard and added a filter. The author anticipated this filter to be applied to all visualizations on the dashboard but it was only on some of them.
Why did this happen?

Question53: A report author wants to add calculations that were created in the published package to a report.
Where can this be done?

Question54: A business manager wants to set the current Dashboard as the home page.
Which mode allows this task?

Question55: A report author wants to enhance a report by having the ability to display the data by region and filter by Order method (where Order method includes: Email, Fax, Post, Sales rep, Promo, Phone, Web site).

How can this be accomplished?

Question56: A company's marketing report tracks performance of various advertising campaigns. All of the advertising media files are stored on an internal file server and can be accessed directly in the URI form file://adserver/ adnnnnnn.mov (where nnnnnn is the same advertisement ID that's used in the marketing performance report).
How can the report author provide users with a clickable download link for the media file in the report performance list?

Question57: A company is using a model that was created in Compatible Query Mode (CQM). There is a report that must reference query subjects from two different packages.
How can this be accomplished?

Question58: A user is creating a join relationship in a Data module.
What benefit can be expected from setting a filter join?